﻿CREATE PROCEDURE dbo.GetUser
	(
	@UserLoginName nvarchar(50),
	@Pass nvarchar(50)
	)

AS
	print @PASS;
	/* SET NOCOUNT ON */
	select UserId,UserName,Email,AllianceId 
	from [User]
    where UserLoginName = @UserLoginName
	and UserPassword = @Pass
	FOR XML AUTO, ELEMENTS;
